Pandas Profiling Report

Dataset statistics

Number of variables	41
Number of observations	1013986
Missing cells	14263504
Missing cells (%)	34.3%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.8 GiB
Average record size in memory	1.8 KiB

Variable types

CAT	20
UNSUPPORTED	14
NUM	7

Reproduction

Analysis started	2022-12-16 21:02:02.385646
Analysis finished	2022-12-16 21:06:45.275177
Duration	4 minutes and 42.89 seconds
Version	pandas-profiling v2.7.1
Command line	`pandas_profiling --config_file config.yaml [YOUR_FILE.csv]`
Download configuration	config.yaml

`Agency` has constant value "HPD"	Constant
`Complaint Type` has constant value "HEAT/HOT WATER"	Constant
`Location Type` has constant value "RESIDENTIAL BUILDING"	Constant
`Park Facility Name` has constant value "Unspecified"	Constant
`Created Date` has a high cardinality: 981277 distinct values	High cardinality
`Closed Date` has a high cardinality: 278282 distinct values	High cardinality
`Incident Address` has a high cardinality: 82894 distinct values	High cardinality
`Street Name` has a high cardinality: 5068 distinct values	High cardinality
`City` has a high cardinality: 87 distinct values	High cardinality
`Resolution Action Updated Date` has a high cardinality: 213342 distinct values	High cardinality
`Community Board` has a high cardinality: 71 distinct values	High cardinality
`Location` has a high cardinality: 85329 distinct values	High cardinality
`BBL` is highly correlated with `Incident Zip`	High correlation
`Incident Zip` is highly correlated with `BBL`	High correlation
`Latitude` is highly correlated with `Y Coordinate (State Plane)`	High correlation
`Y Coordinate (State Plane)` is highly correlated with `Latitude`	High correlation
`Longitude` is highly correlated with `X Coordinate (State Plane)`	High correlation
`X Coordinate (State Plane)` is highly correlated with `Longitude`	High correlation
`Borough` is highly correlated with `Community Board` and 1 other fields	High correlation
`Community Board` is highly correlated with `Borough` and 1 other fields	High correlation
`Park Borough` is highly correlated with `Community Board` and 1 other fields	High correlation
`Cross Street 1` has 1013986 (100.0%) missing values	Missing
`Cross Street 2` has 1013986 (100.0%) missing values	Missing
`Intersection Street 1` has 1013986 (100.0%) missing values	Missing
`Intersection Street 2` has 1013986 (100.0%) missing values	Missing
`Landmark` has 1013986 (100.0%) missing values	Missing
`Facility Type` has 1013986 (100.0%) missing values	Missing
`Due Date` has 1013986 (100.0%) missing values	Missing
`BBL` has 10690 (1.1%) missing values	Missing
`Vehicle Type` has 1013986 (100.0%) missing values	Missing
`Taxi Company Borough` has 1013986 (100.0%) missing values	Missing
`Taxi Pick Up Location` has 1013986 (100.0%) missing values	Missing
`Bridge Highway Name` has 1013986 (100.0%) missing values	Missing
`Bridge Highway Direction` has 1013986 (100.0%) missing values	Missing
`Road Ramp` has 1013986 (100.0%) missing values	Missing
`Bridge Highway Segment` has 1013986 (100.0%) missing values	Missing
`Created Date` is uniformly distributed	Uniform
`Unique Key` has unique values	Unique
`Cross Street 1` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Cross Street 2` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Intersection Street 1` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Intersection Street 2` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Landmark` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Facility Type` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Due Date` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Vehicle Type` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Taxi Company Borough` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Taxi Pick Up Location` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Bridge Highway Name` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Bridge Highway Direction` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Road Ramp` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Bridge Highway Segment` is an unsupported type, check if it needs cleaning or further analysis	Unsupported

Unique Key
Real number (ℝ_≥0)

UNIQUE

Distinct count	1013986
Unique (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	43130257.056178294
Minimum	35139948
Maximum	52934200
Zeros	0
Zeros (%)	0.0%
Memory size	7.7 MiB

Quantile statistics

Minimum	35139948
5-th percentile	35519600.25
Q1	38214325.25
median	41783978.5
Q3	48068128.75
95-th percentile	52528982.75
Maximum	52934200
Range	17794252
Interquartile range (IQR)	9853803.5

Descriptive statistics

Standard deviation	5305137.844
Coefficient of variation (CV)	0.1230026948
Kurtosis	-1.123085758
Mean	43130257.06
Median Absolute Deviation (MAD)	3853779.5
Skewness	0.2883078079
Sum	4.373347683e+13
Variance	2.814448754e+13

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
37748736	1	< 0.1%
52800024	1	< 0.1%
48587600	1	< 0.1%
38122011	1	< 0.1%
38111772	1	< 0.1%
48298278	1	< 0.1%
38113823	1	< 0.1%
52718112	1	< 0.1%
48521761	1	< 0.1%
38923535	1	< 0.1%
Other values (1013976)	1013976	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
35139948	1	< 0.1%
35143918	1	< 0.1%
35143919	1	< 0.1%
35143920	1	< 0.1%
35143921	1	< 0.1%

Value	Count	Frequency (%)
52934200	1	< 0.1%
52931496	1	< 0.1%
52931495	1	< 0.1%
52931494	1	< 0.1%
52931482	1	< 0.1%

Created Date
Categorical

HIGH CARDINALITY
UNIFORM

Distinct count	981277
Unique (%)	96.8%
Missing	0
Missing (%)	0.0%
Memory size	7.7 MiB

01/08/2018 12:00:00 AM	21
01/07/2018 12:00:00 AM	17
11/12/2017 12:00:00 AM	16
01/23/2017 12:00:00 AM	16
03/14/2017 12:00:00 AM	13
Other values (981272)	1013903

Value	Count	Frequency (%)
01/08/2018 12:00:00 AM	21	< 0.1%
01/07/2018 12:00:00 AM	17	< 0.1%
11/12/2017 12:00:00 AM	16	< 0.1%
01/23/2017 12:00:00 AM	16	< 0.1%
03/14/2017 12:00:00 AM	13	< 0.1%
11/23/2018 12:00:00 AM	13	< 0.1%
11/10/2017 12:00:00 AM	13	< 0.1%
03/27/2017 12:00:00 AM	12	< 0.1%
03/04/2017 12:00:00 AM	12	< 0.1%
01/01/2018 12:00:00 AM	12	< 0.1%
Other values (981267)	1013841	> 99.9%

Length

Max length	22
Mean length	22
Min length	22

Value	Count	Frequency (%)
Decimal_Number	10	62.5%
Uppercase_Letter	3	18.8%
Other_Punctuation	2	12.5%
Space_Separator	1	6.2%

Value	Count	Frequency (%)
Common	13	81.2%
Latin	3	18.8%

Value	Count	Frequency (%)
ASCII	16	100.0%

Closed Date
Categorical

HIGH CARDINALITY

Distinct count	278282
Unique (%)	27.5%
Missing	985
Missing (%)	0.1%
Memory size	7.7 MiB

10/24/2018 06:56:33 PM	293
11/28/2017 02:07:20 AM	259
11/16/2017 10:09:40 AM	244
03/28/2018 09:52:41 PM	241
11/11/2019 06:49:35 PM	239
Other values (278277)	1011725

Value	Count	Frequency (%)
10/24/2018 06:56:33 PM	293	< 0.1%
11/28/2017 02:07:20 AM	259	< 0.1%
11/16/2017 10:09:40 AM	244	< 0.1%
03/28/2018 09:52:41 PM	241	< 0.1%
11/11/2019 06:49:35 PM	239	< 0.1%
02/20/2019 02:09:53 AM	228	< 0.1%
02/14/2021 06:15:27 PM	180	< 0.1%
10/23/2018 02:09:20 AM	167	< 0.1%
10/27/2018 06:43:20 PM	162	< 0.1%
01/29/2019 09:45:59 PM	158	< 0.1%
Other values (278272)	1010830	99.7%
(Missing)	985	0.1%

Length

Max length	22
Mean length	21.98154314
Min length	3

Value	Count	Frequency (%)
Decimal_Number	10	55.6%
Uppercase_Letter	3	16.7%
Other_Punctuation	2	11.1%
Lowercase_Letter	2	11.1%
Space_Separator	1	5.6%

Value	Count	Frequency (%)
Common	13	72.2%
Latin	5	27.8%

Value	Count	Frequency (%)
ASCII	18	100.0%

Agency
Categorical

CONSTANT
REJECTED

Distinct count	1
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.7 MiB

HPD	1013986

Value	Count	Frequency (%)
HPD	1013986	100.0%

Length

Max length	3
Mean length	3
Min length	3

Value	Count	Frequency (%)
Uppercase_Letter	3	100.0%

Value	Count	Frequency (%)
Latin	3	100.0%

Value	Count	Frequency (%)
ASCII	3	100.0%

Agency Name
Categorical

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.7 MiB

Department of Housing Preservation and Development	1013879
Division of Alternative Management	107

Value	Count	Frequency (%)
Department of Housing Preservation and Development	1013879	> 99.9%
Division of Alternative Management	107	< 0.1%

Length

Max length	50
Mean length	49.99831161
Min length	34

Value	Count	Frequency (%)
Lowercase_Letter	16	72.7%
Uppercase_Letter	5	22.7%
Space_Separator	1	4.5%

Value	Count	Frequency (%)
Latin	21	95.5%
Common	1	4.5%

Value	Count	Frequency (%)
ASCII	22	100.0%

Complaint Type
Categorical

CONSTANT
REJECTED

Distinct count	1
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.7 MiB

HEAT/HOT WATER	1013986

Value	Count	Frequency (%)
HEAT/HOT WATER	1013986	100.0%

Length

Max length	14
Mean length	14
Min length	14

Value	Count	Frequency (%)
Uppercase_Letter	7	77.8%
Other_Punctuation	1	11.1%
Space_Separator	1	11.1%

Value	Count	Frequency (%)
Latin	7	77.8%
Common	2	22.2%

Value	Count	Frequency (%)
ASCII	9	100.0%

Descriptor
Categorical

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.7 MiB

ENTIRE BUILDING	658553
APARTMENT ONLY	355433

Value	Count	Frequency (%)
ENTIRE BUILDING	658553	64.9%
APARTMENT ONLY	355433	35.1%

Length

Max length	15
Mean length	14.64946952
Min length	14

Value	Count	Frequency (%)
Uppercase_Letter	15	93.8%
Space_Separator	1	6.2%

Value	Count	Frequency (%)
Latin	15	93.8%
Common	1	6.2%

Value	Count	Frequency (%)
ASCII	16	100.0%

Location Type
Categorical

CONSTANT
REJECTED

Distinct count	1
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.7 MiB

RESIDENTIAL BUILDING	1013986

Value	Count	Frequency (%)
RESIDENTIAL BUILDING	1013986	100.0%

Length

Max length	20
Mean length	20
Min length	20

Value	Count	Frequency (%)
Uppercase_Letter	12	92.3%
Space_Separator	1	7.7%

Value	Count	Frequency (%)
Latin	12	92.3%
Common	1	7.7%

Value	Count	Frequency (%)
ASCII	13	100.0%

Incident Zip
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct count	190
Unique (%)	< 0.1%
Missing	7043
Missing (%)	0.7%
Infinite	0
Infinite (%)	0.0%

Mean	10713.993183328153
Minimum	10001.0
Maximum	12345.0
Zeros	0
Zeros (%)	0.0%
Memory size	7.7 MiB

Quantile statistics

Minimum	10001
5-th percentile	10023
Q1	10452
median	10467
Q3	11223
95-th percentile	11385
Maximum	12345
Range	2344
Interquartile range (IQR)	771

Descriptive statistics

Standard deviation	513.8201629
Coefficient of variation (CV)	0.04795785793
Kurtosis	-1.540497936
Mean	10713.99318
Median Absolute Deviation (MAD)	442
Skewness	0.03758202946
Sum	1.078838044e+10
Variance	264011.1598

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
11226	35469	3.5%
10458	30056	3.0%
10457	29707	2.9%
10467	29574	2.9%
10468	26945	2.7%
10452	25839	2.5%
10453	25705	2.5%
10462	22878	2.3%
10031	21526	2.1%
11225	20640	2.0%
Other values (180)	738604	72.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
10001	1590	0.2%
10002	7712	0.8%
10003	5362	0.5%
10004	51	< 0.1%
10005	55	< 0.1%

Value	Count	Frequency (%)
12345	2	< 0.1%
11697	8	< 0.1%
11694	1847	0.2%
11693	467	< 0.1%
11692	1471	0.1%

Incident Address
Categorical

HIGH CARDINALITY

Distinct count	82894
Unique (%)	8.2%
Missing	3
Missing (%)	< 0.1%
Memory size	7.7 MiB

89-21 ELMHURST AVENUE	9460
2176 TIEBOUT AVENUE	8134
9511 SHORE ROAD	4781
2040 BRONXDALE AVENUE	3987
1711 FULTON STREET	3165
Other values (82889)	984456

Value	Count	Frequency (%)
89-21 ELMHURST AVENUE	9460	0.9%
2176 TIEBOUT AVENUE	8134	0.8%
9511 SHORE ROAD	4781	0.5%
2040 BRONXDALE AVENUE	3987	0.4%
1711 FULTON STREET	3165	0.3%
1425 DR M L KING JR BOULEVARD	3066	0.3%
2750 HOMECREST AVENUE	2503	0.2%
2664 GRAND CONCOURSE	2463	0.2%
2090 EAST TREMONT AVENUE	2337	0.2%
1025 BOYNTON AVENUE	2301	0.2%
Other values (82884)	971786	95.8%

Length

Max length	38
Mean length	18.71441618
Min length	3

Value	Count	Frequency (%)
Uppercase_Letter	26	61.9%
Decimal_Number	10	23.8%
Other_Punctuation	2	4.8%
Lowercase_Letter	2	4.8%
Dash_Punctuation	1	2.4%
Space_Separator	1	2.4%

Value	Count	Frequency (%)
Latin	28	66.7%
Common	14	33.3%

Value	Count	Frequency (%)
ASCII	42	100.0%

Street Name
Categorical

HIGH CARDINALITY

Distinct count	5068
Unique (%)	0.5%
Missing	3
Missing (%)	< 0.1%
Memory size	7.7 MiB

GRAND CONCOURSE	17957
BROADWAY	11402
TIEBOUT AVENUE	10020
ELMHURST AVENUE	9935
OCEAN AVENUE	8495
Other values (5063)	956174

Value	Count	Frequency (%)
GRAND CONCOURSE	17957	1.8%
BROADWAY	11402	1.1%
TIEBOUT AVENUE	10020	1.0%
ELMHURST AVENUE	9935	1.0%
OCEAN AVENUE	8495	0.8%
ST NICHOLAS AVENUE	7277	0.7%
MORRIS AVENUE	6983	0.7%
DR M L KING JR BOULEVARD	6087	0.6%
BEDFORD AVENUE	5378	0.5%
SHORE ROAD	5274	0.5%
Other values (5058)	925175	91.2%

Length

Max length	32
Mean length	14.12712503
Min length	3

Value	Count	Frequency (%)
Uppercase_Letter	26	63.4%
Decimal_Number	10	24.4%
Lowercase_Letter	2	4.9%
Space_Separator	1	2.4%
Dash_Punctuation	1	2.4%
Other_Punctuation	1	2.4%

Value	Count	Frequency (%)
Latin	28	68.3%
Common	13	31.7%

Value	Count	Frequency (%)
ASCII	41	100.0%

Cross Street 1
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	1013986
Missing (%)	100.0%
Memory size	7.7 MiB

Cross Street 2
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	1013986
Missing (%)	100.0%
Memory size	7.7 MiB

Intersection Street 1
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	1013986
Missing (%)	100.0%
Memory size	7.7 MiB

Intersection Street 2
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	1013986
Missing (%)	100.0%
Memory size	7.7 MiB

Address Type
Categorical

Distinct count	1
Unique (%)	< 0.1%
Missing	6740
Missing (%)	0.7%
Memory size	7.7 MiB

ADDRESS	1007246

Value	Count	Frequency (%)
ADDRESS	1007246	99.3%
(Missing)	6740	0.7%

Length

Max length	7
Mean length	6.973411862
Min length	3

Value	Count	Frequency (%)
Uppercase_Letter	5	71.4%
Lowercase_Letter	2	28.6%

Value	Count	Frequency (%)
Latin	7	100.0%

Value	Count	Frequency (%)
ASCII	7	100.0%

City
Categorical

HIGH CARDINALITY

Distinct count	87
Unique (%)	< 0.1%
Missing	6947
Missing (%)	0.7%
Memory size	7.7 MiB

BRONX	337191
BROOKLYN	300702
NEW YORK	222864
Elmhurst	14334
Jamaica	13189
Other values (82)	118759

Value	Count	Frequency (%)
BRONX	337191	33.3%
BROOKLYN	300702	29.7%
NEW YORK	222864	22.0%
Elmhurst	14334	1.4%
Jamaica	13189	1.3%
Flushing	11947	1.2%
Astoria	10734	1.1%
STATEN ISLAND	10323	1.0%
Ridgewood	7621	0.8%
Woodside	6663	0.7%
Other values (77)	71471	7.0%
(Missing)	6947	0.7%

Length

Max length	19
Mean length	7.236024955
Min length	3

Value	Count	Frequency (%)
Uppercase_Letter	26	52.0%
Lowercase_Letter	23	46.0%
Space_Separator	1	2.0%

Value	Count	Frequency (%)
Latin	49	98.0%
Common	1	2.0%

Value	Count	Frequency (%)
ASCII	50	100.0%

Landmark
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	1013986
Missing (%)	100.0%
Memory size	7.7 MiB

Facility Type
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	1013986
Missing (%)	100.0%
Memory size	7.7 MiB

Status
Categorical

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.7 MiB

Closed	1013001
Open	985

Value	Count	Frequency (%)
Closed	1013001	99.9%
Open	985	0.1%

Length

Max length	6
Mean length	5.998057172
Min length	4

Value	Count	Frequency (%)
Lowercase_Letter	7	77.8%
Uppercase_Letter	2	22.2%

Value	Count	Frequency (%)
Latin	9	100.0%

Value	Count	Frequency (%)
ASCII	9	100.0%

Due Date
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	1013986
Missing (%)	100.0%
Memory size	7.7 MiB

Resolution Description
Categorical

Distinct count	24
Unique (%)	< 0.1%
Missing	65
Missing (%)	< 0.1%
Memory size	7.7 MiB

The complaint you filed is a duplicate of a condition already reported by another tenant for a building-wide condition. The original complaint is still open. HPD may attempt to contact you to verify the correction of the condition or may conduct an inspection of your unit if the original complainant is not available for verification.	304469
The Department of Housing Preservation and Development responded to a complaint of no heat or hot water and was advised by a tenant in the building that heat and hot water had been restored. If the condition still exists, please file a new complaint.	241689
The Department of Housing Preservation and Development was not able to gain access to your apartment or others in the building to inspect for a lack of heat or hot water. The complaint has been closed. If the condition still exists, please file a new complaint.	135538
The Department of Housing Preservation and Development conducted or attempted to conduct an inspection. More information about inspection results can be found through HPD's website at www.nyc.gov/hpd by using HPDONLINE (enter your address on the home page) and entering your SR number under the complaint status option.	85005
The Department of Housing Preservation and Development inspected the following conditions. No violations were issued. The complaint has been closed.	84354
Other values (19)	162866

Value	Count	Frequency (%)
The complaint you filed is a duplicate of a condition already reported by another tenant for a building-wide condition. The original complaint is still open. HPD may attempt to contact you to verify the correction of the condition or may conduct an inspection of your unit if the original complainant is not available for verification.	304469	30.0%
The Department of Housing Preservation and Development responded to a complaint of no heat or hot water and was advised by a tenant in the building that heat and hot water had been restored. If the condition still exists, please file a new complaint.	241689	23.8%
The Department of Housing Preservation and Development was not able to gain access to your apartment or others in the building to inspect for a lack of heat or hot water. The complaint has been closed. If the condition still exists, please file a new complaint.	135538	13.4%
The Department of Housing Preservation and Development conducted or attempted to conduct an inspection. More information about inspection results can be found through HPD's website at www.nyc.gov/hpd by using HPDONLINE (enter your address on the home page) and entering your SR number under the complaint status option.	85005	8.4%
The Department of Housing Preservation and Development inspected the following conditions. No violations were issued. The complaint has been closed.	84354	8.3%
The Department of Housing Preservation and Development contacted an occupant of the apartment and verified that the following conditions were corrected. The complaint has been closed. If the condition still exists, please file a new complaint.	49306	4.9%
The Department of Housing Preservation and Development contacted a tenant in the building and verified that the following conditions were corrected. The complaint has been closed. If the condition still exists, please file a new complaint.	39723	3.9%
The Department of Housing Preservation and Development inspected the following conditions. Violations were issued. Information about specific violations is available at www.nyc.gov/hpd.	32453	3.2%
The Department of Housing Preservation and Development has closed this complaint administratively. More information can be found through HPD's website at www.nyc.gov/hpd by using HPDONLINE (enter your address on the home page) and entering your SR number under the complaint status option.	19503	1.9%
The following complaint conditions are still open. HPD may attempt to contact you to verify the correction of the condition or may conduct an inspection.	6434	0.6%
Other values (14)	15447	1.5%

Length

Max length	382
Mean length	271.6016612
Min length	3

Value	Count	Frequency (%)
Lowercase_Letter	24	38.7%
Uppercase_Letter	20	32.3%
Decimal_Number	10	16.1%
Other_Punctuation	4	6.5%
Close_Punctuation	1	1.6%
Open_Punctuation	1	1.6%
Dash_Punctuation	1	1.6%
Space_Separator	1	1.6%

Value	Count	Frequency (%)
Latin	44	71.0%
Common	18	29.0%

Value	Count	Frequency (%)
ASCII	62	100.0%

Resolution Action Updated Date
Categorical

HIGH CARDINALITY

Distinct count	213342
Unique (%)	21.0%
Missing	0
Missing (%)	0.0%
Memory size	7.7 MiB

11/08/2021 12:00:00 AM	2599
01/31/2021 12:00:00 AM	2575
02/06/2021 12:00:00 AM	2430
12/02/2021 12:00:00 AM	2139
11/17/2021 12:00:00 AM	2052
Other values (213337)	1002191

Value	Count	Frequency (%)
11/08/2021 12:00:00 AM	2599	0.3%
01/31/2021 12:00:00 AM	2575	0.3%
02/06/2021 12:00:00 AM	2430	0.2%
12/02/2021 12:00:00 AM	2139	0.2%
11/17/2021 12:00:00 AM	2052	0.2%
12/01/2021 12:00:00 AM	1967	0.2%
02/04/2021 12:00:00 AM	1952	0.2%
11/03/2021 12:00:00 AM	1917	0.2%
11/30/2021 12:00:00 AM	1867	0.2%
02/07/2021 12:00:00 AM	1852	0.2%
Other values (213332)	992636	97.9%

Length

Max length	22
Mean length	22
Min length	22

Value	Count	Frequency (%)
Decimal_Number	10	62.5%
Uppercase_Letter	3	18.8%
Other_Punctuation	2	12.5%
Space_Separator	1	6.2%

Value	Count	Frequency (%)
Common	13	81.2%
Latin	3	18.8%

Value	Count	Frequency (%)
ASCII	16	100.0%

Community Board
Categorical

HIGH CARDINALITY
HIGH CORRELATION

Distinct count	71
Unique (%)	< 0.1%
Missing	3
Missing (%)	< 0.1%
Memory size	7.7 MiB

12 MANHATTAN	59424
07 BRONX	52942
05 BRONX	49353
04 BRONX	49142
17 BROOKLYN	36040
Other values (66)	767082

Value	Count	Frequency (%)
12 MANHATTAN	59424	5.9%
07 BRONX	52942	5.2%
05 BRONX	49353	4.9%
04 BRONX	49142	4.8%
17 BROOKLYN	36040	3.6%
14 BROOKLYN	35505	3.5%
10 MANHATTAN	33296	3.3%
09 BRONX	33144	3.3%
09 BROOKLYN	29580	2.9%
09 MANHATTAN	29142	2.9%
Other values (61)	606415	59.8%

Length

Max length	25
Mean length	10.17407538
Min length	3

Value	Count	Frequency (%)
Uppercase_Letter	18	47.4%
Decimal_Number	10	26.3%
Lowercase_Letter	9	23.7%
Space_Separator	1	2.6%

Value	Count	Frequency (%)
Latin	27	71.1%
Common	11	28.9%

Value	Count	Frequency (%)
ASCII	38	100.0%

BBL
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct count	73801
Unique (%)	7.4%
Missing	10690
Missing (%)	1.1%
Infinite	0
Infinite (%)	0.0%

Mean	2410982162.161106
Minimum	0.0
Maximum	5080470023.0
Zeros	55
Zeros (%)	< 0.1%
Memory size	7.7 MiB

Quantile statistics

Minimum	0
5-th percentile	1011950018
Q1	2024650001
median	2042380027
Q3	3051050043
95-th percentile	4091940007
Maximum	5080470023
Range	5080470023
Interquartile range (IQR)	1026400042

Descriptive statistics

Standard deviation	1014767451
Coefficient of variation (CV)	0.4208938029
Kurtosis	-0.788163981
Mean	2410982162
Median Absolute Deviation (MAD)	1006420007
Skewness	0.222454617
Sum	2.418928759e+15
Variance	1.029752979e+18

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
4015110001	9448	0.9%
2031430130	8133	0.8%
3061207502	4773	0.5%
2042850005	3964	0.4%
2039447501	3784	0.4%
3016910012	3165	0.3%
2025370047	3066	0.3%
3087640010	2470	0.2%
2033040010	2462	0.2%
2037140054	2301	0.2%
Other values (73791)	959730	94.6%
(Missing)	10690	1.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	55	< 0.1%
1000020001	1	< 0.1%
1000070038	1	< 0.1%
1000077501	5	< 0.1%
1000110001	1	< 0.1%

Value	Count	Frequency (%)
5080470023	1	< 0.1%
5080460052	2	< 0.1%
5080450006	5	< 0.1%
5080390006	1	< 0.1%
5080370061	1	< 0.1%

Borough
Categorical

HIGH CORRELATION

Distinct count	6
Unique (%)	< 0.1%
Missing	3
Missing (%)	< 0.1%
Memory size	7.7 MiB

BRONX	339152
BROOKLYN	302875
MANHATTAN	224734
QUEENS	136834
STATEN ISLAND	10385

Value	Count	Frequency (%)
BRONX	339152	33.4%
BROOKLYN	302875	29.9%
MANHATTAN	224734	22.2%
QUEENS	136834	13.5%
STATEN ISLAND	10385	1.0%
Unspecified	3	< 0.1%
(Missing)	3	< 0.1%

Length

Max length	13
Mean length	6.99952169
Min length	3

Value	Count	Frequency (%)
Uppercase_Letter	18	64.3%
Lowercase_Letter	9	32.1%
Space_Separator	1	3.6%

Value	Count	Frequency (%)
Latin	27	96.4%
Common	1	3.6%

Value	Count	Frequency (%)
ASCII	28	100.0%

X Coordinate (State Plane)
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct count	47269
Unique (%)	4.7%
Missing	7043
Missing (%)	0.7%
Infinite	0
Infinite (%)	0.0%

Mean	1006545.3696038405
Minimum	914556.0
Maximum	1067122.0
Zeros	0
Zeros (%)	0.0%
Memory size	7.7 MiB

Quantile statistics

Minimum	914556
5-th percentile	984760
Q1	997353
median	1005750
Q3	1015162
95-th percentile	1032631
Maximum	1067122
Range	152566
Interquartile range (IQR)	17809

Descriptive statistics

Standard deviation	15122.62567
Coefficient of variation (CV)	0.01502428617
Kurtosis	2.011595376
Mean	1006545.37
Median Absolute Deviation (MAD)	8731
Skewness	0.1128997854
Sum	1.013533814e+12
Variance	228693807.2

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1018372	9440	0.9%
1012350	8134	0.8%
973626	4773	0.5%
1021173	3964	0.4%
1005083	3078	0.3%
1003545	2848	0.3%
996391	2354	0.2%
1023616	2325	0.2%
1013537	2322	0.2%
1013908	2297	0.2%
Other values (47259)	965408	95.2%
(Missing)	7043	0.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
914556	1	< 0.1%
914756	13	< 0.1%
914811	1	< 0.1%
914970	1	< 0.1%
915001	1	< 0.1%

Value	Count	Frequency (%)
1067122	2	< 0.1%
1067100	3	< 0.1%
1067099	1	< 0.1%
1067060	4	< 0.1%
1067046	2	< 0.1%

Y Coordinate (State Plane)
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct count	58007
Unique (%)	5.8%
Missing	7043
Missing (%)	0.7%
Infinite	0
Infinite (%)	0.0%

Mean	216783.51011030417
Minimum	122081.0
Maximum	271639.0
Zeros	0
Zeros (%)	0.0%
Memory size	7.7 MiB

Quantile statistics

Minimum	122081
5-th percentile	163174
Q1	185589.5
median	222226
Q3	246572
95-th percentile	258290
Maximum	271639
Range	149558
Interquartile range (IQR)	60982.5

Descriptive statistics

Standard deviation	32688.64739
Coefficient of variation (CV)	0.150789363
Kurtosis	-1.294529913
Mean	216783.5101
Median Absolute Deviation (MAD)	27820
Skewness	-0.3071329701
Sum	2.18288638e+11
Variance	1068547668

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
211606	9435	0.9%
250589	8134	0.8%
163839	4773	0.5%
249273	3964	0.4%
246580	3069	0.3%
186786	2791	0.3%
152155	2354	0.2%
254950	2331	0.2%
246058	2320	0.2%
239723	2299	0.2%
Other values (57997)	965473	95.2%
(Missing)	7043	0.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
122081	7	< 0.1%
122175	2	< 0.1%
122507	1	< 0.1%
122518	1	< 0.1%
122953	1	< 0.1%

Value	Count	Frequency (%)
271639	2	< 0.1%
271583	1	< 0.1%
271409	1	< 0.1%
271328	1	< 0.1%
271250	2	< 0.1%

Open Data Channel Type
Categorical

Distinct count	3
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.7 MiB

PHONE	521227
ONLINE	320033
MOBILE	172726

Value	Count	Frequency (%)
PHONE	521227	51.4%
ONLINE	320033	31.6%
MOBILE	172726	17.0%

Length

Max length	6
Mean length	5.485962331
Min length	5

Value	Count	Frequency (%)
Uppercase_Letter	9	100.0%

Value	Count	Frequency (%)
Latin	9	100.0%

Value	Count	Frequency (%)
ASCII	9	100.0%

Park Facility Name
Categorical

CONSTANT
REJECTED

Distinct count	1
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.7 MiB

Unspecified	1013986

Value	Count	Frequency (%)
Unspecified	1013986	100.0%

Length

Max length	11
Mean length	11
Min length	11

Value	Count	Frequency (%)
Lowercase_Letter	8	88.9%
Uppercase_Letter	1	11.1%

Value	Count	Frequency (%)
Latin	9	100.0%

Value	Count	Frequency (%)
ASCII	9	100.0%

Park Borough
Categorical

HIGH CORRELATION

Distinct count	6
Unique (%)	< 0.1%
Missing	3
Missing (%)	< 0.1%
Memory size	7.7 MiB

BRONX	339152
BROOKLYN	302875
MANHATTAN	224734
QUEENS	136834
STATEN ISLAND	10385

Value	Count	Frequency (%)
BRONX	339152	33.4%
BROOKLYN	302875	29.9%
MANHATTAN	224734	22.2%
QUEENS	136834	13.5%
STATEN ISLAND	10385	1.0%
Unspecified	3	< 0.1%
(Missing)	3	< 0.1%

Length

Max length	13
Mean length	6.99952169
Min length	3

Value	Count	Frequency (%)
Uppercase_Letter	18	64.3%
Lowercase_Letter	9	32.1%
Space_Separator	1	3.6%

Value	Count	Frequency (%)
Latin	27	96.4%
Common	1	3.6%

Value	Count	Frequency (%)
ASCII	28	100.0%

Vehicle Type
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	1013986
Missing (%)	100.0%
Memory size	7.7 MiB

Taxi Company Borough
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	1013986
Missing (%)	100.0%
Memory size	7.7 MiB

Taxi Pick Up Location
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	1013986
Missing (%)	100.0%
Memory size	7.7 MiB

Bridge Highway Name
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	1013986
Missing (%)	100.0%
Memory size	7.7 MiB

Bridge Highway Direction
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	1013986
Missing (%)	100.0%
Memory size	7.7 MiB

Road Ramp
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	1013986
Missing (%)	100.0%
Memory size	7.7 MiB

Bridge Highway Segment
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	1013986
Missing (%)	100.0%
Memory size	7.7 MiB

Latitude
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct count	85329
Unique (%)	8.5%
Missing	7043
Missing (%)	0.7%
Infinite	0
Infinite (%)	0.0%

Mean	40.76165547838995
Minimum	40.50150695570338
Maximum	40.91221758090332
Zeros	0
Zeros (%)	0.0%
Memory size	7.7 MiB

Quantile statistics

Minimum	40.50150696
5-th percentile	40.61454225
Q1	40.67603145
median	40.77662647
Q3	40.84342648
95-th percentile	40.87556453
Maximum	40.91221758
Range	0.4107106252
Interquartile range (IQR)	0.1673950244

Descriptive statistics

Standard deviation	0.08971736958
Coefficient of variation (CV)	0.002201023696
Kurtosis	-1.294606905
Mean	40.76165548
Median Absolute Deviation (MAD)	0.07633946117
Skewness	-0.3071820114
Sum	41044663.65
Variance	0.008049206405

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
40.74742033	9410	0.9%
40.8544391	8133	0.8%
40.61637027	4773	0.5%
40.85079459	3964	0.4%
40.84345572	3066	0.3%
40.67934016	2790	0.3%
40.58429811	2354	0.2%
40.86640487	2321	0.2%
40.84195982	2313	0.2%
40.82459453	2295	0.2%
Other values (85319)	965524	95.2%
(Missing)	7043	0.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
40.50150696	7	< 0.1%
40.5017699	2	< 0.1%
40.5026674	1	< 0.1%
40.5027036	1	< 0.1%
40.50389674	1	< 0.1%

Value	Count	Frequency (%)
40.91221758	2	< 0.1%
40.91206287	1	< 0.1%
40.91158732	1	< 0.1%
40.91136264	1	< 0.1%
40.91114555	2	< 0.1%

Longitude
Real number (ℝ)

HIGH CORRELATION

Distinct count	85329
Unique (%)	8.5%
Missing	7043
Missing (%)	0.7%
Infinite	0
Infinite (%)	0.0%

Mean	-73.91949324785969
Minimum	-74.25064221795266
Maximum	-73.70093754842728
Zeros	0
Zeros (%)	0.0%
Memory size	7.7 MiB

Quantile statistics

Minimum	-74.25064222
5-th percentile	-73.99816189
Q1	-73.95274327
median	-73.92238083
Q3	-73.88835247
95-th percentile	-73.82536934
Maximum	-73.70093755
Range	0.5497046695
Interquartile range (IQR)	0.06439079828

Descriptive statistics

Standard deviation	0.05457925523
Coefficient of variation (CV)	-0.0007383607873
Kurtosis	1.988998837
Mean	-73.91949325
Median Absolute Deviation (MAD)	0.03155598175
Skewness	0.1106265704
Sum	-74432716.29
Variance	0.002978895101

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
-73.87685301	9410	0.9%
-73.89842337	8133	0.8%
-74.03826694	4773	0.5%
-73.86653704	3964	0.4%
-73.92470475	3066	0.3%
-73.93043506	2790	0.3%
-73.95628992	2354	0.2%
-73.89411351	2321	0.2%
-73.85772539	2313	0.2%
-73.87729914	2295	0.2%
Other values (85319)	965524	95.2%
(Missing)	7043	0.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-74.25064222	1	< 0.1%
-74.24992323	13	< 0.1%
-74.24972456	1	< 0.1%
-74.24915576	1	< 0.1%
-74.2490386	1	< 0.1%

Value	Count	Frequency (%)
-73.70093755	2	< 0.1%
-73.7010117	3	< 0.1%
-73.70101524	1	< 0.1%
-73.70115242	3	< 0.1%
-73.70115317	1	< 0.1%

Location
Categorical

HIGH CARDINALITY

Distinct count	85329
Unique (%)	8.5%
Missing	7043
Missing (%)	0.7%
Memory size	7.7 MiB

(40.747420328856705, -73.87685300997468)	9410
(40.85443910241399, -73.8984233658015)	8133
(40.61637026983262, -74.03826694457253)	4773
(40.850794587937656, -73.86653703997725)	3964
(40.84345572380287, -73.92470475387987)	3066
Other values (85324)	977597

Value	Count	Frequency (%)
(40.747420328856705, -73.87685300997468)	9410	0.9%
(40.85443910241399, -73.8984233658015)	8133	0.8%
(40.61637026983262, -74.03826694457253)	4773	0.5%
(40.850794587937656, -73.86653703997725)	3964	0.4%
(40.84345572380287, -73.92470475387987)	3066	0.3%
(40.67934015517145, -73.93043505876992)	2790	0.3%
(40.58429811390181, -73.95628992267918)	2354	0.2%
(40.86640486876999, -73.89411351479727)	2321	0.2%
(40.84195981610547, -73.85772539024822)	2313	0.2%
(40.824594531459304, -73.8772991398564)	2295	0.2%
Other values (85319)	965524	95.2%
(Missing)	7043	0.7%

Length

Max length	40
Mean length	38.80981296
Min length	3

Value	Count	Frequency (%)
Decimal_Number	10	55.6%
Other_Punctuation	2	11.1%
Lowercase_Letter	2	11.1%
Close_Punctuation	1	5.6%
Open_Punctuation	1	5.6%
Space_Separator	1	5.6%
Dash_Punctuation	1	5.6%

Value	Count	Frequency (%)
Common	16	88.9%
Latin	2	11.1%

Value	Count	Frequency (%)
ASCII	18	100.0%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

First rows

	Unique Key	Created Date	Closed Date	Agency	Agency Name	Complaint Type	Descriptor	Location Type	Incident Zip	Incident Address	Street Name	Cross Street 1	Cross Street 2	Intersection Street 1	Intersection Street 2	Address Type	City	Landmark	Facility Type	Status	Due Date	Resolution Description	Resolution Action Updated Date	Community Board	BBL	Borough	X Coordinate (State Plane)	Y Coordinate (State Plane)	Open Data Channel Type	Park Facility Name	Park Borough	Vehicle Type	Taxi Company Borough	Taxi Pick Up Location	Bridge Highway Name	Bridge Highway Direction	Road Ramp	Bridge Highway Segment	Latitude	Longitude	Location
0	37666285	11/12/2017 12:00:00 AM	01/22/2018 12:00:00 AM	HPD	Department of Housing Preservation and Development	HEAT/HOT WATER	APARTMENT ONLY	RESIDENTIAL BUILDING	10034.0	165 SHERMAN AVENUE	SHERMAN AVENUE	NaN	NaN	NaN	NaN	ADDRESS	NEW YORK	NaN	NaN	Closed	NaN	The Department of Housing Preservation and Development has closed this complaint administratively. Please file a new complaint through 311MOBILE, 311ONLINE or by calling 311 if the condition still exists.	01/22/2018 12:00:00 AM	12 MANHATTAN	1.022210e+09	MANHATTAN	1005613.0	254344.0	PHONE	Unspecified	MANHATTAN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	40.864764	-73.922764	(40.86476431663921, -73.92276447154296)
1	37675276	11/12/2017 12:00:00 AM	04/08/2019 12:00:00 AM	HPD	Department of Housing Preservation and Development	HEAT/HOT WATER	APARTMENT ONLY	RESIDENTIAL BUILDING	10454.0	353 EAST 141 STREET	EAST 141 STREET	NaN	NaN	NaN	NaN	ADDRESS	BRONX	NaN	NaN	Closed	NaN	The Department of Housing Preservation and Development has closed this complaint administratively. Please file a new complaint through 311MOBILE, 311ONLINE or by calling 311 if the condition still exists.	04/08/2019 12:00:00 AM	01 BRONX	2.023040e+09	BRONX	1005674.0	234944.0	ONLINE	Unspecified	BRONX	NaN	NaN	NaN	NaN	NaN	NaN	NaN	40.811517	-73.922606	(40.81151682281859, -73.92260590193087)
2	37682385	11/13/2017 12:00:00 AM	11/13/2017 12:00:00 AM	HPD	Department of Housing Preservation and Development	HEAT/HOT WATER	ENTIRE BUILDING	RESIDENTIAL BUILDING	11238.0	374 PROSPECT PLACE	PROSPECT PLACE	NaN	NaN	NaN	NaN	ADDRESS	BROOKLYN	NaN	NaN	Closed	NaN	The Department of Housing Preservation and Development has closed this complaint administratively. Please file a new complaint through 311MOBILE, 311ONLINE or by calling 311 if the condition still exists.	11/13/2017 12:00:00 AM	08 BROOKLYN	3.011600e+09	BROOKLYN	994136.0	185823.0	ONLINE	Unspecified	BROOKLYN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	40.676712	-73.964359	(40.67671244686174, -73.96435906406927)
3	38112583	01/04/2018 12:00:00 AM	03/18/2018 12:00:00 AM	HPD	Department of Housing Preservation and Development	HEAT/HOT WATER	ENTIRE BUILDING	RESIDENTIAL BUILDING	10031.0	38 ST NICHOLAS PLACE	ST NICHOLAS PLACE	NaN	NaN	NaN	NaN	ADDRESS	NEW YORK	NaN	NaN	Closed	NaN	The Department of Housing Preservation and Development has closed this complaint administratively. Please file a new complaint through 311MOBILE, 311ONLINE or by calling 311 if the condition still exists.	03/18/2018 12:00:00 AM	09 MANHATTAN	1.020540e+09	MANHATTAN	1000450.0	241141.0	PHONE	Unspecified	MANHATTAN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	40.828537	-73.941463	(40.82853696054143, -73.94146261055029)
4	38792282	03/27/2018 12:00:00 AM	03/28/2018 12:00:00 AM	HPD	Department of Housing Preservation and Development	HEAT/HOT WATER	ENTIRE BUILDING	RESIDENTIAL BUILDING	11216.0	159 HALSEY STREET	HALSEY STREET	NaN	NaN	NaN	NaN	ADDRESS	BROOKLYN	NaN	NaN	Closed	NaN	The Department of Housing Preservation and Development has closed this complaint administratively. Please file a new complaint through 311MOBILE, 311ONLINE or by calling 311 if the condition still exists.	03/28/2018 12:00:00 AM	03 BROOKLYN	3.018380e+09	BROOKLYN	998843.0	187787.0	PHONE	Unspecified	BROOKLYN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	40.682097	-73.947385	(40.68209667277928, -73.9473851721007)
5	38793312	03/27/2018 12:00:00 AM	03/30/2018 12:00:00 AM	HPD	Department of Housing Preservation and Development	HEAT/HOT WATER	ENTIRE BUILDING	RESIDENTIAL BUILDING	11203.0	374 EAST 49 STREET	EAST 49 STREET	NaN	NaN	NaN	NaN	ADDRESS	BROOKLYN	NaN	NaN	Closed	NaN	The Department of Housing Preservation and Development has closed this complaint administratively. Please file a new complaint through 311MOBILE, 311ONLINE or by calling 311 if the condition still exists.	03/30/2018 12:00:00 AM	17 BROOKLYN	3.046740e+09	BROOKLYN	1003252.0	177119.0	ONLINE	Unspecified	BROOKLYN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	40.652807	-73.931519	(40.65280703038938, -73.9315186685526)
6	38799862	03/27/2018 12:00:00 AM	04/04/2018 12:00:00 AM	HPD	Department of Housing Preservation and Development	HEAT/HOT WATER	ENTIRE BUILDING	RESIDENTIAL BUILDING	10034.0	165 SHERMAN AVENUE	SHERMAN AVENUE	NaN	NaN	NaN	NaN	ADDRESS	NEW YORK	NaN	NaN	Closed	NaN	The Department of Housing Preservation and Development has closed this complaint administratively. Please file a new complaint through 311MOBILE, 311ONLINE or by calling 311 if the condition still exists.	04/04/2018 12:00:00 AM	12 MANHATTAN	1.022210e+09	MANHATTAN	1005613.0	254344.0	PHONE	Unspecified	MANHATTAN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	40.864764	-73.922764	(40.86476431663921, -73.92276447154296)
7	36871751	08/04/2017 02:26:11 AM	08/05/2017 02:46:11 AM	HPD	Department of Housing Preservation and Development	HEAT/HOT WATER	ENTIRE BUILDING	RESIDENTIAL BUILDING	11201.0	284 ATLANTIC AVENUE	ATLANTIC AVENUE	NaN	NaN	NaN	NaN	ADDRESS	BROOKLYN	NaN	NaN	Closed	NaN	The Department of Housing Preservation and Development has closed this complaint administratively. More information can be found through HPD's website at www.nyc.gov/hpd by using HPDONLINE (enter your address on the home page) and entering your SR number under the complaint status option.	08/05/2017 02:46:11 AM	02 BROOKLYN	3.001810e+09	BROOKLYN	987141.0	190205.0	ONLINE	Unspecified	BROOKLYN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	40.688745	-73.989576	(40.68874508704761, -73.98957550708268)
8	36949988	08/15/2017 08:04:39 AM	08/17/2017 02:06:36 AM	HPD	Department of Housing Preservation and Development	HEAT/HOT WATER	APARTMENT ONLY	RESIDENTIAL BUILDING	11206.0	417 LORIMER STREET	LORIMER STREET	NaN	NaN	NaN	NaN	ADDRESS	BROOKLYN	NaN	NaN	Closed	NaN	The complaint you filed is a duplicate of a condition already reported by another tenant for a building-wide condition. The original complaint is still open. HPD may attempt to contact you to verify the correction of the condition or may conduct an inspection of your unit if the original complainant is not available for verification.	08/17/2017 02:06:36 AM	01 BROOKLYN	3.030220e+09	BROOKLYN	998497.0	197731.0	MOBILE	Unspecified	BROOKLYN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	40.709391	-73.948612	(40.70939120268948, -73.94861163637752)
9	36951576	08/15/2017 07:12:41 PM	08/18/2017 02:14:04 AM	HPD	Department of Housing Preservation and Development	HEAT/HOT WATER	ENTIRE BUILDING	RESIDENTIAL BUILDING	11238.0	575 GRAND AVENUE	GRAND AVENUE	NaN	NaN	NaN	NaN	ADDRESS	BROOKLYN	NaN	NaN	Closed	NaN	The Department of Housing Preservation and Development was not able to gain access to your apartment or others in the building to inspect for a lack of heat or hot water. The complaint has been closed. If the condition still exists, please file a new complaint.	08/18/2017 02:14:04 AM	08 BROOKLYN	3.011480e+09	BROOKLYN	994712.0	186288.0	PHONE	Unspecified	BROOKLYN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	40.677988	-73.962282	(40.67798810469399, -73.96228175142863)

Last rows

	Unique Key	Created Date	Closed Date	Agency	Agency Name	Complaint Type	Descriptor	Location Type	Incident Zip	Incident Address	Street Name	Cross Street 1	Cross Street 2	Intersection Street 1	Intersection Street 2	Address Type	City	Landmark	Facility Type	Status	Due Date	Resolution Description	Resolution Action Updated Date	Community Board	BBL	Borough	X Coordinate (State Plane)	Y Coordinate (State Plane)	Open Data Channel Type	Park Facility Name	Park Borough	Vehicle Type	Taxi Company Borough	Taxi Pick Up Location	Bridge Highway Name	Bridge Highway Direction	Road Ramp	Bridge Highway Segment	Latitude	Longitude	Location
1013976	42053310	03/25/2019 11:07:02 AM	03/27/2019 07:29:23 AM	HPD	Department of Housing Preservation and Development	HEAT/HOT WATER	ENTIRE BUILDING	RESIDENTIAL BUILDING	11233.0	205 SUMPTER STREET	SUMPTER STREET	NaN	NaN	NaN	NaN	ADDRESS	BROOKLYN	NaN	NaN	Closed	NaN	The Department of Housing Preservation and Development inspected the following conditions. No violations were issued. The complaint has been closed.	03/27/2019 07:29:23 AM	03 BROOKLYN	3.015190e+09	BROOKLYN	1007129.0	187133.0	PHONE	Unspecified	BROOKLYN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	40.680284	-73.917512	(40.680284053302664, -73.9175123666471)
1013977	42053306	03/25/2019 09:45:28 AM	03/27/2019 11:58:16 AM	HPD	Department of Housing Preservation and Development	HEAT/HOT WATER	ENTIRE BUILDING	RESIDENTIAL BUILDING	11230.0	1585 EAST 14 STREET	EAST 14 STREET	NaN	NaN	NaN	NaN	ADDRESS	BROOKLYN	NaN	NaN	Closed	NaN	The Department of Housing Preservation and Development responded to a complaint of no heat or hot water and was advised by a tenant in the building that heat and hot water had been restored. If the condition still exists, please file a new complaint.	03/27/2019 11:58:16 AM	14 BROOKLYN	3.067610e+09	BROOKLYN	995459.0	161861.0	PHONE	Unspecified	BROOKLYN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	40.610940	-73.959629	(40.61094034785047, -73.95962920796566)
1013978	42053286	03/25/2019 09:05:45 PM	03/27/2019 02:07:47 AM	HPD	Department of Housing Preservation and Development	HEAT/HOT WATER	ENTIRE BUILDING	RESIDENTIAL BUILDING	10452.0	1425 DR M L KING JR BOULEVARD	DR M L KING JR BOULEVARD	NaN	NaN	NaN	NaN	ADDRESS	BRONX	NaN	NaN	Closed	NaN	The complaint you filed is a duplicate of a condition already reported by another tenant for a building-wide condition. The original complaint is still open. HPD may attempt to contact you to verify the correction of the condition or may conduct an inspection of your unit if the original complainant is not available for verification.	03/27/2019 02:07:47 AM	04 BRONX	2.025370e+09	BRONX	1005083.0	246580.0	MOBILE	Unspecified	BRONX	NaN	NaN	NaN	NaN	NaN	NaN	NaN	40.843456	-73.924705	(40.84345572380287, -73.92470475387987)
1013979	42053318	03/25/2019 09:21:58 PM	03/27/2019 08:34:59 AM	HPD	Department of Housing Preservation and Development	HEAT/HOT WATER	ENTIRE BUILDING	RESIDENTIAL BUILDING	10456.0	3475 3 AVENUE	3 AVENUE	NaN	NaN	NaN	NaN	ADDRESS	BRONX	NaN	NaN	Closed	NaN	The complaint you filed is a duplicate of a condition already reported by another tenant for a building-wide condition. The original complaint is still open. HPD may attempt to contact you to verify the correction of the condition or may conduct an inspection of your unit if the original complainant is not available for verification.	03/27/2019 08:34:59 AM	03 BRONX	2.023720e+09	BRONX	1010177.0	241700.0	PHONE	Unspecified	BRONX	NaN	NaN	NaN	NaN	NaN	NaN	NaN	40.830048	-73.906313	(40.83004805755818, -73.90631274439146)
1013980	42053287	03/25/2019 08:46:38 AM	03/27/2019 05:27:21 PM	HPD	Department of Housing Preservation and Development	HEAT/HOT WATER	ENTIRE BUILDING	RESIDENTIAL BUILDING	10458.0	2968 PERRY AVENUE	PERRY AVENUE	NaN	NaN	NaN	NaN	ADDRESS	BRONX	NaN	NaN	Closed	NaN	The complaint you filed is a duplicate of a condition already reported by another tenant for a building-wide condition. The original complaint is still open. HPD may attempt to contact you to verify the correction of the condition or may conduct an inspection of your unit if the original complainant is not available for verification.	03/27/2019 05:27:21 PM	07 BRONX	2.032920e+09	BRONX	1016331.0	256308.0	PHONE	Unspecified	BRONX	NaN	NaN	NaN	NaN	NaN	NaN	NaN	40.870122	-73.884005	(40.87012244969979, -73.88400538088398)
1013981	42053304	03/25/2019 04:44:13 PM	03/27/2019 08:52:07 AM	HPD	Department of Housing Preservation and Development	HEAT/HOT WATER	ENTIRE BUILDING	RESIDENTIAL BUILDING	10469.0	3478 FENTON AVENUE	FENTON AVENUE	NaN	NaN	NaN	NaN	ADDRESS	BRONX	NaN	NaN	Closed	NaN	The complaint you filed is a duplicate of a condition already reported by another tenant for a building-wide condition. The original complaint is still open. HPD may attempt to contact you to verify the correction of the condition or may conduct an inspection of your unit if the original complainant is not available for verification.	03/27/2019 08:52:07 AM	12 BRONX	2.047210e+09	BRONX	1026044.0	259103.0	MOBILE	Unspecified	BRONX	NaN	NaN	NaN	NaN	NaN	NaN	NaN	40.877753	-73.848869	(40.87775320807253, -73.84886891043506)
1013982	42053317	03/25/2019 02:45:10 PM	03/27/2019 04:56:33 PM	HPD	Department of Housing Preservation and Development	HEAT/HOT WATER	ENTIRE BUILDING	RESIDENTIAL BUILDING	10462.0	2132 WALLACE AVENUE	WALLACE AVENUE	NaN	NaN	NaN	NaN	ADDRESS	BRONX	NaN	NaN	Closed	NaN	The complaint you filed is a duplicate of a condition already reported by another tenant for a building-wide condition. The original complaint is still open. HPD may attempt to contact you to verify the correction of the condition or may conduct an inspection of your unit if the original complainant is not available for verification.	03/27/2019 04:56:33 PM	11 BRONX	2.042920e+09	BRONX	1021647.0	250439.0	PHONE	Unspecified	BRONX	NaN	NaN	NaN	NaN	NaN	NaN	NaN	40.853993	-73.864817	(40.85399291289473, -73.86481720417432)
1013983	42053292	03/25/2019 06:27:04 AM	03/25/2019 09:14:17 PM	HPD	Department of Housing Preservation and Development	HEAT/HOT WATER	ENTIRE BUILDING	RESIDENTIAL BUILDING	11225.0	486 BROOKLYN AVENUE	BROOKLYN AVENUE	NaN	NaN	NaN	NaN	ADDRESS	BROOKLYN	NaN	NaN	Closed	NaN	The Department of Housing Preservation and Development conducted or attempted to conduct an inspection. More information about inspection results can be found through HPD's website at www.nyc.gov/hpd by using HPDONLINE (enter your address on the home page) and entering your SR number under the complaint status option.	03/25/2019 09:14:17 PM	09 BROOKLYN	3.013220e+09	BROOKLYN	999344.0	180820.0	PHONE	Unspecified	BROOKLYN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	40.662973	-73.945594	(40.66297298421168, -73.94559442643347)
1013984	42053305	03/25/2019 07:35:11 PM	03/27/2019 02:07:56 AM	HPD	Department of Housing Preservation and Development	HEAT/HOT WATER	ENTIRE BUILDING	RESIDENTIAL BUILDING	10461.0	2935 WILKINSON AVENUE	WILKINSON AVENUE	NaN	NaN	NaN	NaN	ADDRESS	BRONX	NaN	NaN	Closed	NaN	The complaint you filed is a duplicate of a condition already reported by another tenant for a building-wide condition. The original complaint is still open. HPD may attempt to contact you to verify the correction of the condition or may conduct an inspection of your unit if the original complainant is not available for verification.	03/27/2019 02:07:56 AM	10 BRONX	2.042450e+09	BRONX	1031086.0	249612.0	ONLINE	Unspecified	BRONX	NaN	NaN	NaN	NaN	NaN	NaN	NaN	40.851678	-73.830703	(40.85167802151147, -73.83070293065111)
1013985	42053288	03/25/2019 10:32:09 PM	03/28/2019 02:07:44 AM	HPD	Department of Housing Preservation and Development	HEAT/HOT WATER	ENTIRE BUILDING	RESIDENTIAL BUILDING	10463.0	2834 HEATH AVENUE	HEATH AVENUE	NaN	NaN	NaN	NaN	ADDRESS	BRONX	NaN	NaN	Closed	NaN	The Department of Housing Preservation and Development responded to a complaint of no heat or hot water and was advised by a tenant in the building that heat and hot water had been restored. If the condition still exists, please file a new complaint.	03/28/2019 02:07:44 AM	08 BRONX	2.032560e+09	BRONX	1010780.0	257535.0	ONLINE	Unspecified	BRONX	NaN	NaN	NaN	NaN	NaN	NaN	NaN	40.873509	-73.904071	(40.87350861612905, -73.90407114254262)

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows